package com.zzyl.mapper;

import com.zzyl.entity.SysUser;
import com.zzyl.vo.LoginUserVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface SysUserMapper {
    @Select("select id from sys_user where username = #{username}")
    Long selectSysUserByName(String username);

    LoginUserVo selectByPrimaryKey(Long id);

    LoginUserVo selectLoginUserByName(String name);

    LoginUserVo selectSysUserByPostNo(@Param("postNo") String postNo);

    Long selectSysUserIdByPostName(String postName);

}

